SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].MarcasSelectCommandByMarca
(
	@MARCA varchar(100)
)
AS
	SET NOCOUNT ON;
SELECT        ID, MARCA, ACTIVO
FROM            MARCAS
WHERE        (MARCA LIKE '%' + @MARCA + '%')
GO
